import os
from datetime import date

import django

# 设置Django环境
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'student.settings')
django.setup()

from StuApp.models import UserInfo, GradeInfo, ClassInfo, StudentInfo


def init_database_full():
    """初始化完整数据库数据（包含所有432个学生）"""
    print("开始初始化完整数据库...")

    # 1. 创建管理员账号
    if not UserInfo.objects.filter(username='admin').exists():
        UserInfo.objects.create(username='admin', password='123456')
        print("✓ 管理员账号已创建: admin/123456")
    else:
        print("✓ 管理员账号已存在")

    # 2. 创建年级信息
    grades_data = [
        {'grade_id': '1', 'grade_year': '2021级'},
        {'grade_id': '2', 'grade_year': '2022级'},
        {'grade_id': '3', 'grade_year': '2023级'},
        {'grade_id': '4', 'grade_year': '2024级'},
    ]

    for grade_data in grades_data:
        if not GradeInfo.objects.filter(grade_id=grade_data['grade_id']).exists():
            GradeInfo.objects.create(**grade_data)
            print(f"✓ 年级已创建: {grade_data['grade_year']}")

    # 3. 创建班级信息
    classes_data = [
        # 2021级 (大一) 班级
        {'class_id': 101, 'class_name': '1班', 'grade_id': '1'},
        {'class_id': 102, 'class_name': '2班', 'grade_id': '1'},
        {'class_id': 103, 'class_name': '3班', 'grade_id': '1'},
        # 2022级 (大二) 班级
        {'class_id': 201, 'class_name': '1班', 'grade_id': '2'},
        {'class_id': 202, 'class_name': '2班', 'grade_id': '2'},
        {'class_id': 203, 'class_name': '3班', 'grade_id': '2'},
        # 2023级 (大三) 班级
        {'class_id': 301, 'class_name': '1班', 'grade_id': '3'},
        {'class_id': 302, 'class_name': '2班', 'grade_id': '3'},
        {'class_id': 303, 'class_name': '3班', 'grade_id': '3'},
        # 2024级 (大四) 班级
        {'class_id': 401, 'class_name': '1班', 'grade_id': '4'},
        {'class_id': 402, 'class_name': '2班', 'grade_id': '4'},
        {'class_id': 403, 'class_name': '3班', 'grade_id': '4'},
    ]

    for class_data in classes_data:
        if not ClassInfo.objects.filter(class_id=class_data['class_id']).exists():
            grade = GradeInfo.objects.get(grade_id=class_data['grade_id'])
            ClassInfo.objects.create(
                class_id=class_data['class_id'],
                class_name=class_data['class_name'],
                grade_id=grade
            )
            print(f"✓ 班级已创建: {grade.grade_year}{class_data['class_name']}")

    # 4. 创建所有学生信息 (432个学生)
    students_data = [
        {'student_id': '20210102', 'student_name': '李华', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 5, 22), 'student_phone': '13800010002', 'class_id': 101},
        {'student_id': '20210103', 'student_name': '王伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 11, 30), 'student_phone': '13800010003', 'class_id': 101},
        {'student_id': '20210104', 'student_name': '赵敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 8, 14), 'student_phone': '13800010004', 'class_id': 101},
        {'student_id': '20210105', 'student_name': '刘强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 2, 18), 'student_phone': '13800010005', 'class_id': 101},
        {'student_id': '20210106', 'student_name': '陈静', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 7, 25), 'student_phone': '13800010006', 'class_id': 101},
        {'student_id': '20210107', 'student_name': '杨帆', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 4, 11), 'student_phone': '13800010007', 'class_id': 101},
        {'student_id': '20210108', 'student_name': '黄丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 9, 3), 'student_phone': '13800010008', 'class_id': 101},
        {'student_id': '20210109', 'student_name': '周杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 12, 19), 'student_phone': '13800010009', 'class_id': 101},
        {'student_id': '20210110', 'student_name': '吴婷', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 6, 28), 'student_phone': '13800010010', 'class_id': 101},
        {'student_id': '20210111', 'student_name': '郑浩', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 1, 5), 'student_phone': '13800010011', 'class_id': 101},
        {'student_id': '20210112', 'student_name': '孙燕', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 10, 17), 'student_phone': '13800010012', 'class_id': 101},
        {'student_id': '20210113', 'student_name': '朱军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 7, 21), 'student_phone': '13800010013', 'class_id': 101},
        {'student_id': '20210114', 'student_name': '马琳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 3, 8), 'student_phone': '13800010014', 'class_id': 101},
        {'student_id': '20210115', 'student_name': '胡伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 5, 12), 'student_phone': '13800010015', 'class_id': 101},
        {'student_id': '20210116', 'student_name': '林芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 11, 25), 'student_phone': '13800010016', 'class_id': 101},
        {'student_id': '20210117', 'student_name': '高翔', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 8, 14), 'student_phone': '13800010017', 'class_id': 101},
        {'student_id': '20210118', 'student_name': '何敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 4, 6), 'student_phone': '13800010018', 'class_id': 101},
        {'student_id': '20210119', 'student_name': '罗刚', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 10, 9), 'student_phone': '13800010019', 'class_id': 101},
        {'student_id': '20210120', 'student_name': '梁娟', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 2, 23), 'student_phone': '13800010020', 'class_id': 101},
        {'student_id': '20210121', 'student_name': '宋阳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 6, 30), 'student_phone': '13800010021', 'class_id': 101},
        {'student_id': '20210122', 'student_name': '谢娜', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 12, 11), 'student_phone': '13800010022', 'class_id': 101},
        {'student_id': '20210123', 'student_name': '唐勇', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 9, 5), 'student_phone': '13800010023', 'class_id': 101},
        {'student_id': '20210124', 'student_name': '韩雪', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 1, 18), 'student_phone': '13800010024', 'class_id': 101},
        {'student_id': '20210125', 'student_name': '董超', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 3, 26), 'student_phone': '13800010025', 'class_id': 101},
        {'student_id': '20210126', 'student_name': '萧红', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 7, 19), 'student_phone': '13800010026', 'class_id': 101},
        {'student_id': '20210127', 'student_name': '范伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 11, 22), 'student_phone': '13800010027', 'class_id': 101},
        {'student_id': '20210128', 'student_name': '彭丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 5, 14), 'student_phone': '13800010028', 'class_id': 101},
        {'student_id': '20210129', 'student_name': '曾强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 2, 7), 'student_phone': '13800010029', 'class_id': 101},
        {'student_id': '20210130', 'student_name': '苏梅', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 8, 29), 'student_phone': '13800010030', 'class_id': 101},
        {'student_id': '20210131', 'student_name': '潘杰', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 4, 15), 'student_phone': '13800010031', 'class_id': 101},
        {'student_id': '20210132', 'student_name': '葛菲', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 10, 3), 'student_phone': '13800010032', 'class_id': 101},
        {'student_id': '20210133', 'student_name': '郎平', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 12, 24), 'student_phone': '13800010033', 'class_id': 101},
        {'student_id': '20210134', 'student_name': '韦芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 6, 17), 'student_phone': '13800010034', 'class_id': 101},
        {'student_id': '20210135', 'student_name': '傅军', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 1, 28), 'student_phone': '13800010035', 'class_id': 101},
        {'student_id': '20210136', 'student_name': '方敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 9, 9), 'student_phone': '13800010036', 'class_id': 101},

        # 2021级2班 (36人)
        {'student_id': '20210201', 'student_name': '徐明', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 3, 10), 'student_phone': '13800020001', 'class_id': 102},
        {'student_id': '20210202', 'student_name': '沈华', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 5, 15), 'student_phone': '13800020002', 'class_id': 102},
        {'student_id': '20210203', 'student_name': '曹伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 11, 25), 'student_phone': '13800020003', 'class_id': 102},
        {'student_id': '20210204', 'student_name': '许敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 8, 19), 'student_phone': '13800020004', 'class_id': 102},
        {'student_id': '20210205', 'student_name': '邓强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 2, 22), 'student_phone': '13800020005', 'class_id': 102},
        {'student_id': '20210206', 'student_name': '蔡静', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 7, 28), 'student_phone': '13800020006', 'class_id': 102},
        {'student_id': '20210207', 'student_name': '杜帆', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 4, 16), 'student_phone': '13800020007', 'class_id': 102},
        {'student_id': '20210208', 'student_name': '夏丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 9, 7), 'student_phone': '13800020008', 'class_id': 102},
        {'student_id': '20210209', 'student_name': '汪杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 12, 23), 'student_phone': '13800020009', 'class_id': 102},
        {'student_id': '20210210', 'student_name': '田婷', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 6, 29), 'student_phone': '13800020010', 'class_id': 102},
        {'student_id': '20210211', 'student_name': '任浩', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 1, 8), 'student_phone': '13800020011', 'class_id': 102},
        {'student_id': '20210212', 'student_name': '姜燕', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 10, 22), 'student_phone': '13800020012', 'class_id': 102},
        {'student_id': '20210213', 'student_name': '范军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 7, 26), 'student_phone': '13800020013', 'class_id': 102},
        {'student_id': '20210214', 'student_name': '石琳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 3, 11), 'student_phone': '13800020014', 'class_id': 102},
        {'student_id': '20210215', 'student_name': '姚伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 5, 19), 'student_phone': '13800020015', 'class_id': 102},
        {'student_id': '20210216', 'student_name': '谭芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 11, 28), 'student_phone': '13800020016', 'class_id': 102},
        {'student_id': '20210217', 'student_name': '邹翔', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 8, 18), 'student_phone': '13800020017', 'class_id': 102},
        {'student_id': '20210218', 'student_name': '熊敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 4, 9), 'student_phone': '13800020018', 'class_id': 102},
        {'student_id': '20210219', 'student_name': '金刚', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 10, 12), 'student_phone': '13800020019', 'class_id': 102},
        {'student_id': '20210220', 'student_name': '陆娟', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 2, 27), 'student_phone': '13800020020', 'class_id': 102},
        {'student_id': '20210221', 'student_name': '郝阳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 6, 24), 'student_phone': '13800020021', 'class_id': 102},
        {'student_id': '20210222', 'student_name': '顾娜', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 12, 14), 'student_phone': '13800020022', 'class_id': 102},
        {'student_id': '20210223', 'student_name': '侯勇', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 9, 8), 'student_phone': '13800020023', 'class_id': 102},
        {'student_id': '20210224', 'student_name': '孟雪', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 1, 21), 'student_phone': '13800020024', 'class_id': 102},
        {'student_id': '20210225', 'student_name': '龙超', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 3, 29), 'student_phone': '13800020025', 'class_id': 102},
        {'student_id': '20210226', 'student_name': '万红', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 7, 22), 'student_phone': '13800020026', 'class_id': 102},
        {'student_id': '20210227', 'student_name': '段伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 11, 18), 'student_phone': '13800020027', 'class_id': 102},
        {'student_id': '20210228', 'student_name': '钱丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 5, 17), 'student_phone': '13800020028', 'class_id': 102},
        {'student_id': '20210229', 'student_name': '汤强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 2, 11), 'student_phone': '13800020029', 'class_id': 102},
        {'student_id': '20210230', 'student_name': '尹梅', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 8, 31), 'student_phone': '13800020030', 'class_id': 102},
        {'student_id': '20210231', 'student_name': '黎杰', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 4, 18), 'student_phone': '13800020031', 'class_id': 102},
        {'student_id': '20210232', 'student_name': '易菲', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 10, 7), 'student_phone': '13800020032', 'class_id': 102},
        {'student_id': '20210233', 'student_name': '常平', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 12, 27), 'student_phone': '13800020033', 'class_id': 102},
        {'student_id': '20210234', 'student_name': '武芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 6, 20), 'student_phone': '13800020034', 'class_id': 102},
        {'student_id': '20210235', 'student_name': '乔军', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 1, 31), 'student_phone': '13800020035', 'class_id': 102},
        {'student_id': '20210236', 'student_name': '贺敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 9, 12), 'student_phone': '13800020036', 'class_id': 102},

        # 2021级3班 (36人)
        {'student_id': '20210301', 'student_name': '吕伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 7, 12), 'student_phone': '13800030001', 'class_id': 103},
        {'student_id': '20210302', 'student_name': '卢芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 8, 19), 'student_phone': '13800030002', 'class_id': 103},
        {'student_id': '20210303', 'student_name': '丁明', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 3, 14), 'student_phone': '13800030003', 'class_id': 103},
        {'student_id': '20210304', 'student_name': '邓华', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 5, 20), 'student_phone': '13800030004', 'class_id': 103},
        {'student_id': '20210305', 'student_name': '叶伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 11, 27), 'student_phone': '13800030005', 'class_id': 103},
        {'student_id': '20210306', 'student_name': '白敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 8, 16), 'student_phone': '13800030006', 'class_id': 103},
        {'student_id': '20210307', 'student_name': '崔强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 2, 20), 'student_phone': '13800030007', 'class_id': 103},
        {'student_id': '20210308', 'student_name': '钟静', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 7, 30), 'student_phone': '13800030008', 'class_id': 103},
        {'student_id': '20210309', 'student_name': '田帆', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 4, 13), 'student_phone': '13800030009', 'class_id': 103},
        {'student_id': '20210310', 'student_name': '姜丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 9, 5), 'student_phone': '13800030010', 'class_id': 103},
        {'student_id': '20210311', 'student_name': '范杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 12, 21), 'student_phone': '13800030011', 'class_id': 103},
        {'student_id': '20210312', 'student_name': '石婷', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 6, 27), 'student_phone': '13800030012', 'class_id': 103},
        {'student_id': '20210313', 'student_name': '姚浩', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 1, 9), 'student_phone': '13800030013', 'class_id': 103},
        {'student_id': '20210314', 'student_name': '谭燕', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 10, 19), 'student_phone': '13800030014', 'class_id': 103},
        {'student_id': '20210315', 'student_name': '邹军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 7, 28), 'student_phone': '13800030015', 'class_id': 103},
        {'student_id': '20210316', 'student_name': '熊琳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 3, 13), 'student_phone': '13800030016', 'class_id': 103},
        {'student_id': '20210317', 'student_name': '金伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 5, 21), 'student_phone': '13800030017', 'class_id': 103},
        {'student_id': '20210318', 'student_name': '陆芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 11, 29), 'student_phone': '13800030018', 'class_id': 103},
        {'student_id': '20210319', 'student_name': '郝翔', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 8, 19), 'student_phone': '13800030019', 'class_id': 103},
        {'student_id': '20210320', 'student_name': '顾敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 4, 11), 'student_phone': '13800030020', 'class_id': 103},
        {'student_id': '20210321', 'student_name': '侯刚', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 10, 14), 'student_phone': '13800030021', 'class_id': 103},
        {'student_id': '20210322', 'student_name': '孟娟', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 2, 25), 'student_phone': '13800030022', 'class_id': 103},
        {'student_id': '20210323', 'student_name': '龙阳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 6, 26), 'student_phone': '13800030023', 'class_id': 103},
        {'student_id': '20210324', 'student_name': '万娜', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 12, 16), 'student_phone': '13800030024', 'class_id': 103},
        {'student_id': '20210325', 'student_name': '段勇', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 9, 10), 'student_phone': '13800030025', 'class_id': 103},
        {'student_id': '20210326', 'student_name': '钱雪', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 1, 24), 'student_phone': '13800030026', 'class_id': 103},
        {'student_id': '20210327', 'student_name': '汤超', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 3, 31), 'student_phone': '13800030027', 'class_id': 103},
        {'student_id': '20210328', 'student_name': '尹红', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 7, 23), 'student_phone': '13800030028', 'class_id': 103},
        {'student_id': '20210329', 'student_name': '黎伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 11, 20), 'student_phone': '13800030029', 'class_id': 103},
        {'student_id': '20210330', 'student_name': '易丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 5, 19), 'student_phone': '13800030030', 'class_id': 103},
        {'student_id': '20210331', 'student_name': '常强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 2, 13), 'student_phone': '13800030031', 'class_id': 103},
        {'student_id': '20210332', 'student_name': '武梅', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 8, 30), 'student_phone': '13800030032', 'class_id': 103},
        {'student_id': '20210333', 'student_name': '乔杰', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2000, 4, 20), 'student_phone': '13800030033', 'class_id': 103},
        {'student_id': '20210334', 'student_name': '贺菲', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2001, 10, 10), 'student_phone': '13800030034', 'class_id': 103},
        {'student_id': '20210335', 'student_name': '吕平', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2000, 12, 29), 'student_phone': '13800030035', 'class_id': 103},
        {'student_id': '20210336', 'student_name': '卢芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2001, 6, 22), 'student_phone': '13800030036', 'class_id': 103},

        # 2022级1班 (36人)
        {'student_id': '20220101', 'student_name': '丁杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 3, 15), 'student_phone': '13800110001', 'class_id': 201},
        {'student_id': '20220102', 'student_name': '邓丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 5, 22), 'student_phone': '13800110002', 'class_id': 201},
        {'student_id': '20220103', 'student_name': '崔明', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 11, 30), 'student_phone': '13800110003', 'class_id': 201},
        {'student_id': '20220104', 'student_name': '钟华', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 14), 'student_phone': '13800110004', 'class_id': 201},
        {'student_id': '20220105', 'student_name': '谭伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 2, 18), 'student_phone': '13800110005', 'class_id': 201},
        {'student_id': '20220106', 'student_name': '邱芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 7, 25), 'student_phone': '13800110006', 'class_id': 201},
        {'student_id': '20220107', 'student_name': '邵敏', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 11), 'student_phone': '13800110007', 'class_id': 201},
        {'student_id': '20220108', 'student_name': '汪杰', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 9, 3), 'student_phone': '13800110008', 'class_id': 201},
        {'student_id': '20220109', 'student_name': '毛婷', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 12, 19), 'student_phone': '13800110009', 'class_id': 201},
        {'student_id': '20220110', 'student_name': '田浩', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 6, 28), 'student_phone': '13800110010', 'class_id': 201},
        {'student_id': '20220111', 'student_name': '任燕', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 1, 5), 'student_phone': '13800110011', 'class_id': 201},
        {'student_id': '20220112', 'student_name': '姜军', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 10, 17), 'student_phone': '13800110012', 'class_id': 201},
        {'student_id': '20220113', 'student_name': '范琳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 7, 21), 'student_phone': '13800110013', 'class_id': 201},
        {'student_id': '20220114', 'student_name': '石伟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 3, 8), 'student_phone': '13800110014', 'class_id': 201},
        {'student_id': '20220115', 'student_name': '姚芳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 5, 12), 'student_phone': '13800110015', 'class_id': 201},
        {'student_id': '20220116', 'student_name': '谭翔', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 11, 25), 'student_phone': '13800110016', 'class_id': 201},
        {'student_id': '20220117', 'student_name': '邹敏', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 8, 14), 'student_phone': '13800110017', 'class_id': 201},
        {'student_id': '20220118', 'student_name': '熊娟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 4, 6), 'student_phone': '13800110018', 'class_id': 201},
        {'student_id': '20220119', 'student_name': '金阳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 10, 9), 'student_phone': '13800110019', 'class_id': 201},
        {'student_id': '20220120', 'student_name': '陆娜', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 2, 23), 'student_phone': '13800110020', 'class_id': 201},
        {'student_id': '20220121', 'student_name': '郝勇', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 6, 30), 'student_phone': '13800110021', 'class_id': 201},
        {'student_id': '20220122', 'student_name': '顾雪', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 12, 11), 'student_phone': '13800110022', 'class_id': 201},
        {'student_id': '20220123', 'student_name': '侯超', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 9, 5), 'student_phone': '13800110023', 'class_id': 201},
        {'student_id': '20220124', 'student_name': '孟红', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 1, 18), 'student_phone': '13800110024', 'class_id': 201},
        {'student_id': '20220125', 'student_name': '龙伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 3, 26), 'student_phone': '13800110025', 'class_id': 201},
        {'student_id': '20220126', 'student_name': '万丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 7, 19), 'student_phone': '13800110026', 'class_id': 201},
        {'student_id': '20220127', 'student_name': '段强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 11, 22), 'student_phone': '13800110027', 'class_id': 201},
        {'student_id': '20220128', 'student_name': '钱梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 5, 14), 'student_phone': '13800110028', 'class_id': 201},
        {'student_id': '20220129', 'student_name': '汤杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 2, 7), 'student_phone': '13800110029', 'class_id': 201},
        {'student_id': '20220130', 'student_name': '尹菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 8, 29), 'student_phone': '13800110030', 'class_id': 201},
        {'student_id': '20220131', 'student_name': '黎平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 15), 'student_phone': '13800110031', 'class_id': 201},
        {'student_id': '20220132', 'student_name': '易芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 10, 3), 'student_phone': '13800110032', 'class_id': 201},
        {'student_id': '20220133', 'student_name': '常军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 12, 24), 'student_phone': '13800110033', 'class_id': 201},
        {'student_id': '20220134', 'student_name': '武敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 6, 17), 'student_phone': '13800110034', 'class_id': 201},
        {'student_id': '20220135', 'student_name': '乔娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 1, 28), 'student_phone': '13800110035', 'class_id': 201},
        {'student_id': '20220136', 'student_name': '贺阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 9, 9), 'student_phone': '13800110036', 'class_id': 201},

        # 2022级2班 (36人)
        {'student_id': '20220201', 'student_name': '崔明', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 18), 'student_phone': '13800120001', 'class_id': 202},
        {'student_id': '20220202', 'student_name': '钟华', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 25), 'student_phone': '13800120002', 'class_id': 202},
        {'student_id': '20220203', 'student_name': '谭伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 11, 28), 'student_phone': '13800120003', 'class_id': 202},
        {'student_id': '20220204', 'student_name': '邱芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 8, 17), 'student_phone': '13800120004', 'class_id': 202},
        {'student_id': '20220205', 'student_name': '邵敏', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 2, 21), 'student_phone': '13800120005', 'class_id': 202},
        {'student_id': '20220206', 'student_name': '汪杰', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 7, 26), 'student_phone': '13800120006', 'class_id': 202},
        {'student_id': '20220207', 'student_name': '毛婷', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 4, 14), 'student_phone': '13800120007', 'class_id': 202},
        {'student_id': '20220208', 'student_name': '田浩', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 9, 6), 'student_phone': '13800120008', 'class_id': 202},
        {'student_id': '20220209', 'student_name': '任燕', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 12, 22), 'student_phone': '13800120009', 'class_id': 202},
        {'student_id': '20220210', 'student_name': '姜军', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 30), 'student_phone': '13800120010', 'class_id': 202},
        {'student_id': '20220211', 'student_name': '范琳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 1, 10), 'student_phone': '13800120011', 'class_id': 202},
        {'student_id': '20220212', 'student_name': '石伟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 10, 20), 'student_phone': '13800120012', 'class_id': 202},
        {'student_id': '20220213', 'student_name': '姚芳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 7, 29), 'student_phone': '13800120013', 'class_id': 202},
        {'student_id': '20220214', 'student_name': '谭翔', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 3, 14), 'student_phone': '13800120014', 'class_id': 202},
        {'student_id': '20220215', 'student_name': '邹敏', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 5, 23), 'student_phone': '13800120015', 'class_id': 202},
        {'student_id': '20220216', 'student_name': '熊娟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 11, 30), 'student_phone': '13800120016', 'class_id': 202},
        {'student_id': '20220217', 'student_name': '金阳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 8, 20), 'student_phone': '13800120017', 'class_id': 202},
        {'student_id': '20220218', 'student_name': '陆娜', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 4, 12), 'student_phone': '13800120018', 'class_id': 202},
        {'student_id': '20220219', 'student_name': '郝勇', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 10, 15), 'student_phone': '13800120019', 'class_id': 202},
        {'student_id': '20220220', 'student_name': '顾雪', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 2, 26), 'student_phone': '13800120020', 'class_id': 202},
        {'student_id': '20220221', 'student_name': '侯超', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 6, 27), 'student_phone': '13800120021', 'class_id': 202},
        {'student_id': '20220222', 'student_name': '孟红', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 12, 17), 'student_phone': '13800120022', 'class_id': 202},
        {'student_id': '20220223', 'student_name': '龙伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 9, 11), 'student_phone': '13800120023', 'class_id': 202},
        {'student_id': '20220224', 'student_name': '万丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 1, 25), 'student_phone': '13800120024', 'class_id': 202},
        {'student_id': '20220225', 'student_name': '段强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 3, 30), 'student_phone': '13800120025', 'class_id': 202},
        {'student_id': '20220226', 'student_name': '钱梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 7, 24), 'student_phone': '13800120026', 'class_id': 202},
        {'student_id': '20220227', 'student_name': '汤杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 11, 21), 'student_phone': '13800120027', 'class_id': 202},
        {'student_id': '20220228', 'student_name': '尹菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 5, 20), 'student_phone': '13800120028', 'class_id': 202},
        {'student_id': '20220229', 'student_name': '黎平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 2, 14), 'student_phone': '13800120029', 'class_id': 202},
        {'student_id': '20220230', 'student_name': '易芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 31), 'student_phone': '13800120030', 'class_id': 202},
        {'student_id': '20220231', 'student_name': '常军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 4, 21), 'student_phone': '13800120031', 'class_id': 202},
        {'student_id': '20220232', 'student_name': '武敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 10, 11), 'student_phone': '13800120032', 'class_id': 202},
        {'student_id': '20220233', 'student_name': '乔娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 12, 30), 'student_phone': '13800120033', 'class_id': 202},
        {'student_id': '20220234', 'student_name': '贺阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 23), 'student_phone': '13800120034', 'class_id': 202},
        {'student_id': '20220235', 'student_name': '崔娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 1, 11), 'student_phone': '13800120035', 'class_id': 202},
        {'student_id': '20220236', 'student_name': '钟勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 9, 13), 'student_phone': '13800120036', 'class_id': 202},

        # 2022级3班 (36人)
        {'student_id': '20220301', 'student_name': '谭伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 8, 11), 'student_phone': '13800130001', 'class_id': 203},
        {'student_id': '20220302', 'student_name': '邱芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 9, 3), 'student_phone': '13800130002', 'class_id': 203},
        {'student_id': '20220303', 'student_name': '邵敏', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 3, 17), 'student_phone': '13800130003', 'class_id': 203},
        {'student_id': '20220304', 'student_name': '汪杰', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 5, 24), 'student_phone': '13800130004', 'class_id': 203},
        {'student_id': '20220305', 'student_name': '毛婷', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 11, 29), 'student_phone': '13800130005', 'class_id': 203},
        {'student_id': '20220306', 'student_name': '田浩', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 8, 15), 'student_phone': '13800130006', 'class_id': 203},
        {'student_id': '20220307', 'student_name': '任燕', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 2, 19), 'student_phone': '13800130007', 'class_id': 203},
        {'student_id': '20220308', 'student_name': '姜军', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 7, 27), 'student_phone': '13800130008', 'class_id': 203},
        {'student_id': '20220309', 'student_name': '范琳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 4, 12), 'student_phone': '13800130009', 'class_id': 203},
        {'student_id': '20220310', 'student_name': '石伟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 9, 8), 'student_phone': '13800130010', 'class_id': 203},
        {'student_id': '20220311', 'student_name': '姚芳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 12, 24), 'student_phone': '13800130011', 'class_id': 203},
        {'student_id': '20220312', 'student_name': '谭翔', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 29), 'student_phone': '13800130012', 'class_id': 203},
        {'student_id': '20220313', 'student_name': '邹敏', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 1, 12), 'student_phone': '13800130013', 'class_id': 203},
        {'student_id': '20220314', 'student_name': '熊娟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 10, 21), 'student_phone': '13800130014', 'class_id': 203},
        {'student_id': '20220315', 'student_name': '金阳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 7, 30), 'student_phone': '13800130015', 'class_id': 203},
        {'student_id': '20220316', 'student_name': '陆娜', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 3, 15), 'student_phone': '13800130016', 'class_id': 203},
        {'student_id': '20220317', 'student_name': '郝勇', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 5, 24), 'student_phone': '13800130017', 'class_id': 203},
        {'student_id': '20220318', 'student_name': '顾雪', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 11, 29), 'student_phone': '13800130018', 'class_id': 203},
        {'student_id': '20220319', 'student_name': '侯超', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 8, 21), 'student_phone': '13800130019', 'class_id': 203},
        {'student_id': '20220320', 'student_name': '孟红', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 4, 13), 'student_phone': '13800130020', 'class_id': 203},
        {'student_id': '20220321', 'student_name': '龙伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 10, 16), 'student_phone': '13800130021', 'class_id': 203},
        {'student_id': '20220322', 'student_name': '万丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 2, 28), 'student_phone': '13800130022', 'class_id': 203},
        {'student_id': '20220323', 'student_name': '段强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 6, 28), 'student_phone': '13800130023', 'class_id': 203},
        {'student_id': '20220324', 'student_name': '钱梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 12, 18), 'student_phone': '13800130024', 'class_id': 203},
        {'student_id': '20220325', 'student_name': '汤杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 9, 12), 'student_phone': '13800130025', 'class_id': 203},
        {'student_id': '20220326', 'student_name': '尹菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 1, 26), 'student_phone': '13800130026', 'class_id': 203},
        {'student_id': '20220327', 'student_name': '黎平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 3, 31), 'student_phone': '13800130027', 'class_id': 203},
        {'student_id': '20220328', 'student_name': '易芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 7, 25), 'student_phone': '13800130028', 'class_id': 203},
        {'student_id': '20220329', 'student_name': '常军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 11, 23), 'student_phone': '13800130029', 'class_id': 203},
        {'student_id': '20220330', 'student_name': '武敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 5, 21), 'student_phone': '13800130030', 'class_id': 203},
        {'student_id': '20220331', 'student_name': '乔娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 2, 15), 'student_phone': '13800130031', 'class_id': 203},
        {'student_id': '20220332', 'student_name': '贺阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 30), 'student_phone': '13800130032', 'class_id': 203},
        {'student_id': '20220333', 'student_name': '崔娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 4, 22), 'student_phone': '13800130033', 'class_id': 203},
        {'student_id': '20220334', 'student_name': '钟勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 10, 12), 'student_phone': '13800130034', 'class_id': 203},
        {'student_id': '20220335', 'student_name': '谭雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 12, 31), 'student_phone': '13800130035', 'class_id': 203},
        {'student_id': '20220336', 'student_name': '邱超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 24), 'student_phone': '13800130036', 'class_id': 203},
        # 2023级1班 (36人)
        {'student_id': '20230101', 'student_name': '林伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 3, 12), 'student_phone': '13800210001', 'class_id': 301},
        {'student_id': '20230102', 'student_name': '韩芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 5, 18), 'student_phone': '13800210002', 'class_id': 301},
        {'student_id': '20230103', 'student_name': '高敏', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 11, 26), 'student_phone': '13800210003', 'class_id': 301},
        {'student_id': '20230104', 'student_name': '谢杰', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 8, 13), 'student_phone': '13800210004', 'class_id': 301},
        {'student_id': '20230105', 'student_name': '宋婷', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 2, 17), 'student_phone': '13800210005', 'class_id': 301},
        {'student_id': '20230106', 'student_name': '郑浩', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 7, 24), 'student_phone': '13800210006', 'class_id': 301},
        {'student_id': '20230107', 'student_name': '王燕', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 4, 10), 'student_phone': '13800210007', 'class_id': 301},
        {'student_id': '20230108', 'student_name': '冯军', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 9, 2), 'student_phone': '13800210008', 'class_id': 301},
        {'student_id': '20230109', 'student_name': '程琳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 12, 18), 'student_phone': '13800210009', 'class_id': 301},
        {'student_id': '20230110', 'student_name': '曹伟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 6, 27), 'student_phone': '13800210010', 'class_id': 301},
        {'student_id': '20230111', 'student_name': '彭芳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 1, 4), 'student_phone': '13800210011', 'class_id': 301},
        {'student_id': '20230112', 'student_name': '袁翔', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 10, 16), 'student_phone': '13800210012', 'class_id': 301},
        {'student_id': '20230113', 'student_name': '邓敏', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 7, 20), 'student_phone': '13800210013', 'class_id': 301},
        {'student_id': '20230114', 'student_name': '许娟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 3, 7), 'student_phone': '13800210014', 'class_id': 301},
        {'student_id': '20230115', 'student_name': '张阳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 5, 11), 'student_phone': '13800210015', 'class_id': 301},
        {'student_id': '20230116', 'student_name': '叶娜', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 11, 24), 'student_phone': '13800210016', 'class_id': 301},
        {'student_id': '20230117', 'student_name': '潘勇', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 8, 13), 'student_phone': '13800210017', 'class_id': 301},
        {'student_id': '20230118', 'student_name': '董雪', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 4, 5), 'student_phone': '13800210018', 'class_id': 301},
        {'student_id': '20230119', 'student_name': '苏超', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 10, 8), 'student_phone': '13800210019', 'class_id': 301},
        {'student_id': '20230120', 'student_name': '魏红', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 2, 22), 'student_phone': '13800210020', 'class_id': 301},
        {'student_id': '20230121', 'student_name': '蒋伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 6, 29), 'student_phone': '13800210021', 'class_id': 301},
        {'student_id': '20230122', 'student_name': '沈丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 12, 10), 'student_phone': '13800210022', 'class_id': 301},
        {'student_id': '20230123', 'student_name': '曾强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 9, 4), 'student_phone': '13800210023', 'class_id': 301},
        {'student_id': '20230124', 'student_name': '吴梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 1, 17), 'student_phone': '13800210024', 'class_id': 301},
        {'student_id': '20230125', 'student_name': '蔡杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 3, 25), 'student_phone': '13800210025', 'class_id': 301},
        {'student_id': '20230126', 'student_name': '余菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 7, 18), 'student_phone': '13800210026', 'class_id': 301},
        {'student_id': '20230127', 'student_name': '杜平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 11, 21), 'student_phone': '13800210027', 'class_id': 301},
        {'student_id': '20230128', 'student_name': '夏芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 5, 13), 'student_phone': '13800210028', 'class_id': 301},
        {'student_id': '20230129', 'student_name': '汪军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 2, 6), 'student_phone': '13800210029', 'class_id': 301},
        {'student_id': '20230130', 'student_name': '范敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 8, 28), 'student_phone': '13800210030', 'class_id': 301},
        {'student_id': '20230131', 'student_name': '钟娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 4, 14), 'student_phone': '13800210031', 'class_id': 301},
        {'student_id': '20230132', 'student_name': '田阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 10, 2), 'student_phone': '13800210032', 'class_id': 301},
        {'student_id': '20230133', 'student_name': '姜娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 12, 23), 'student_phone': '13800210033', 'class_id': 301},
        {'student_id': '20230134', 'student_name': '崔勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 6, 16), 'student_phone': '13800210034', 'class_id': 301},
        {'student_id': '20230135', 'student_name': '顾雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 1, 27), 'student_phone': '13800210035', 'class_id': 301},
        {'student_id': '20230136', 'student_name': '侯超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 9, 8), 'student_phone': '13800210036', 'class_id': 301},

        # 2023级2班 (36人)
        {'student_id': '20230201', 'student_name': '徐伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 7, 11), 'student_phone': '13800220001', 'class_id': 302},
        {'student_id': '20230202', 'student_name': '沈芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 8, 18), 'student_phone': '13800220002', 'class_id': 302},
        {'student_id': '20230203', 'student_name': '曹敏', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 3, 13), 'student_phone': '13800220003', 'class_id': 302},
        {'student_id': '20230204', 'student_name': '许杰', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 5, 19), 'student_phone': '13800220004', 'class_id': 302},
        {'student_id': '20230205', 'student_name': '邓婷', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 11, 25), 'student_phone': '13800220005', 'class_id': 302},
        {'student_id': '20230206', 'student_name': '蔡浩', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 8, 14), 'student_phone': '13800220006', 'class_id': 302},
        {'student_id': '20230207', 'student_name': '杜燕', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 2, 18), 'student_phone': '13800220007', 'class_id': 302},
        {'student_id': '20230208', 'student_name': '夏军', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 7, 25), 'student_phone': '13800220008', 'class_id': 302},
        {'student_id': '20230209', 'student_name': '汪琳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 4, 12), 'student_phone': '13800220009', 'class_id': 302},
        {'student_id': '20230210', 'student_name': '范伟', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 9, 4), 'student_phone': '13800220010', 'class_id': 302},
        {'student_id': '20230211', 'student_name': '钟芳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 12, 20), 'student_phone': '13800220011', 'class_id': 302},
        {'student_id': '20230212', 'student_name': '田翔', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 6, 26), 'student_phone': '13800220012', 'class_id': 302},
        {'student_id': '20230213', 'student_name': '姜敏', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 1, 8), 'student_phone': '13800220013', 'class_id': 302},
        {'student_id': '20230214', 'student_name': '崔娟', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 10, 15), 'student_phone': '13800220014', 'class_id': 302},
        {'student_id': '20230215', 'student_name': '顾阳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 7, 27), 'student_phone': '13800220015', 'class_id': 302},
        {'student_id': '20230216', 'student_name': '侯娜', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 3, 12), 'student_phone': '13800220016', 'class_id': 302},
        {'student_id': '20230217', 'student_name': '徐勇', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 5, 20), 'student_phone': '13800220017', 'class_id': 302},
        {'student_id': '20230218', 'student_name': '沈雪', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 11, 28), 'student_phone': '13800220018', 'class_id': 302},
        {'student_id': '20230219', 'student_name': '曹超', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 8, 17), 'student_phone': '13800220019', 'class_id': 302},
        {'student_id': '20230220', 'student_name': '许红', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 4, 10), 'student_phone': '13800220020', 'class_id': 302},
        {'student_id': '20230221', 'student_name': '邓伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 10, 13), 'student_phone': '13800220021', 'class_id': 302},
        {'student_id': '20230222', 'student_name': '蔡丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 2, 24), 'student_phone': '13800220022', 'class_id': 302},
        {'student_id': '20230223', 'student_name': '杜强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 6, 25), 'student_phone': '13800220023', 'class_id': 302},
        {'student_id': '20230224', 'student_name': '夏梅', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 12, 15), 'student_phone': '13800220024', 'class_id': 302},
        {'student_id': '20230225', 'student_name': '汪杰', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 9, 9), 'student_phone': '13800220025', 'class_id': 302},
        {'student_id': '20230226', 'student_name': '范菲', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 1, 25), 'student_phone': '13800220026', 'class_id': 302},
        {'student_id': '20230227', 'student_name': '钟平', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 3, 28), 'student_phone': '13800220027', 'class_id': 302},
        {'student_id': '20230228', 'student_name': '田芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 7, 21), 'student_phone': '13800220028', 'class_id': 302},
        {'student_id': '20230229', 'student_name': '姜军', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 11, 22), 'student_phone': '13800220029', 'class_id': 302},
        {'student_id': '20230230', 'student_name': '崔敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 5, 18), 'student_phone': '13800220030', 'class_id': 302},
        {'student_id': '20230231', 'student_name': '顾娟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 2, 12), 'student_phone': '13800220031', 'class_id': 302},
        {'student_id': '20230232', 'student_name': '侯阳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 8, 27), 'student_phone': '13800220032', 'class_id': 302},
        {'student_id': '20230233', 'student_name': '徐娜', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 4, 19), 'student_phone': '13800220033', 'class_id': 302},
        {'student_id': '20230234', 'student_name': '沈勇', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 10, 9), 'student_phone': '13800220034', 'class_id': 302},
        {'student_id': '20230235', 'student_name': '曹雪', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 12, 30), 'student_phone': '13800220035', 'class_id': 302},
        {'student_id': '20230236', 'student_name': '许超', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 6, 20), 'student_phone': '13800220036', 'class_id': 302},

        # 2023级3班 (36人)
        {'student_id': '20230301', 'student_name': '邓伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 8, 10), 'student_phone': '13800230001', 'class_id': 303},
        {'student_id': '20230302', 'student_name': '蔡芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 9, 2), 'student_phone': '13800230002', 'class_id': 303},
        {'student_id': '20230303', 'student_name': '杜敏', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 3, 16), 'student_phone': '13800230003', 'class_id': 303},
        {'student_id': '20230304', 'student_name': '夏杰', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 5, 23), 'student_phone': '13800230004', 'class_id': 303},
        {'student_id': '20230305', 'student_name': '汪婷', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 11, 28), 'student_phone': '13800230005', 'class_id': 303},
        {'student_id': '20230306', 'student_name': '范浩', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 8, 12), 'student_phone': '13800230006', 'class_id': 303},
        {'student_id': '20230307', 'student_name': '钟燕', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 2, 18), 'student_phone': '13800230007', 'class_id': 303},
        {'student_id': '20230308', 'student_name': '田军', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 7, 26), 'student_phone': '13800230008', 'class_id': 303},
        {'student_id': '20230309', 'student_name': '姜琳', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 4, 11), 'student_phone': '13800230009', 'class_id': 303},
        {'student_id': '20230310', 'student_name': '崔伟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 9, 7), 'student_phone': '13800230010', 'class_id': 303},
        {'student_id': '20230311', 'student_name': '顾芳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 12, 23), 'student_phone': '13800230011', 'class_id': 303},
        {'student_id': '20230312', 'student_name': '侯翔', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 6, 28), 'student_phone': '13800230012', 'class_id': 303},
        {'student_id': '20230313', 'student_name': '徐敏', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 1, 11), 'student_phone': '13800230013', 'class_id': 303},
        {'student_id': '20230314', 'student_name': '沈娟', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 10, 20), 'student_phone': '13800230014', 'class_id': 303},
        {'student_id': '20230315', 'student_name': '曹阳', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 7, 29), 'student_phone': '13800230015', 'class_id': 303},
        {'student_id': '20230316', 'student_name': '许娜', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 3, 14), 'student_phone': '13800230016', 'class_id': 303},
        {'student_id': '20230317', 'student_name': '邓勇', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 5, 23), 'student_phone': '13800230017', 'class_id': 303},
        {'student_id': '20230318', 'student_name': '蔡雪', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 11, 28), 'student_phone': '13800230018', 'class_id': 303},
        {'student_id': '20230319', 'student_name': '杜超', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 8, 20), 'student_phone': '13800230019', 'class_id': 303},
        {'student_id': '20230320', 'student_name': '夏红', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 4, 12), 'student_phone': '13800230020', 'class_id': 303},
        {'student_id': '20230321', 'student_name': '汪伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 10, 15), 'student_phone': '13800230021', 'class_id': 303},
        {'student_id': '20230322', 'student_name': '范丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 2, 27), 'student_phone': '13800230022', 'class_id': 303},
        {'student_id': '20230323', 'student_name': '钟强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 6, 27), 'student_phone': '13800230023', 'class_id': 303},
        {'student_id': '20230324', 'student_name': '田梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 12, 17), 'student_phone': '13800230024', 'class_id': 303},
        {'student_id': '20230325', 'student_name': '姜杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 9, 11), 'student_phone': '13800230025', 'class_id': 303},
        {'student_id': '20230326', 'student_name': '崔菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 1, 24), 'student_phone': '13800230026', 'class_id': 303},
        {'student_id': '20230327', 'student_name': '顾平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 3, 30), 'student_phone': '13800230027', 'class_id': 303},
        {'student_id': '20230328', 'student_name': '侯芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 7, 24), 'student_phone': '13800230028', 'class_id': 303},
        {'student_id': '20230329', 'student_name': '徐军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 11, 20), 'student_phone': '13800230029', 'class_id': 303},
        {'student_id': '20230330', 'student_name': '沈敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 5, 19), 'student_phone': '13800230030', 'class_id': 303},
        {'student_id': '20230331', 'student_name': '曹娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 2, 13), 'student_phone': '13800230031', 'class_id': 303},
        {'student_id': '20230332', 'student_name': '许阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 8, 29), 'student_phone': '13800230032', 'class_id': 303},
        {'student_id': '20230333', 'student_name': '邓娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2001, 4, 20), 'student_phone': '13800230033', 'class_id': 303},
        {'student_id': '20230334', 'student_name': '蔡勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2002, 10, 10), 'student_phone': '13800230034', 'class_id': 303},
        {'student_id': '20230335', 'student_name': '杜雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2001, 12, 29), 'student_phone': '13800230035', 'class_id': 303},
        {'student_id': '20230336', 'student_name': '夏超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2002, 6, 21), 'student_phone': '13800230036', 'class_id': 303},

        # 2024级1班 (36人)
        {'student_id': '20240101', 'student_name': '林杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 3, 11), 'student_phone': '13800310001', 'class_id': 401},
        {'student_id': '20240102', 'student_name': '韩婷', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 5, 17), 'student_phone': '13800310002', 'class_id': 401},
        {'student_id': '20240103', 'student_name': '高浩', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 11, 25), 'student_phone': '13800310003', 'class_id': 401},
        {'student_id': '20240104', 'student_name': '谢燕', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 12), 'student_phone': '13800310004', 'class_id': 401},
        {'student_id': '20240105', 'student_name': '宋军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 2, 16), 'student_phone': '13800310005', 'class_id': 401},
        {'student_id': '20240106', 'student_name': '郑琳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 7, 23), 'student_phone': '13800310006', 'class_id': 401},
        {'student_id': '20240107', 'student_name': '王伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 9), 'student_phone': '13800310007', 'class_id': 401},
        {'student_id': '20240108', 'student_name': '冯芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 9, 1), 'student_phone': '13800310008', 'class_id': 401},
        {'student_id': '20240109', 'student_name': '程翔', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 12, 17), 'student_phone': '13800310009', 'class_id': 401},
        {'student_id': '20240110', 'student_name': '曹敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 6, 26), 'student_phone': '13800310010', 'class_id': 401},
        {'student_id': '20240111', 'student_name': '彭娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 1, 3), 'student_phone': '13800310011', 'class_id': 401},
        {'student_id': '20240112', 'student_name': '袁阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 10, 15), 'student_phone': '13800310012', 'class_id': 401},
        {'student_id': '20240113', 'student_name': '邓娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 7, 19), 'student_phone': '13800310013', 'class_id': 401},
        {'student_id': '20240114', 'student_name': '许勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 3, 6), 'student_phone': '13800310014', 'class_id': 401},
        {'student_id': '20240115', 'student_name': '张雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 5, 10), 'student_phone': '13800310015', 'class_id': 401},
        {'student_id': '20240116', 'student_name': '叶超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 11, 23), 'student_phone': '13800310016', 'class_id': 401},
        {'student_id': '20240117', 'student_name': '潘伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 8, 12), 'student_phone': '13800310017', 'class_id': 401},
        {'student_id': '20240118', 'student_name': '董丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 4, 4), 'student_phone': '13800310018', 'class_id': 401},
        {'student_id': '20240119', 'student_name': '苏强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 10, 7), 'student_phone': '13800310019', 'class_id': 401},
        {'student_id': '20240120', 'student_name': '魏梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 2, 21), 'student_phone': '13800310020', 'class_id': 401},
        {'student_id': '20240121', 'student_name': '蒋杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 6, 28), 'student_phone': '13800310021', 'class_id': 401},
        {'student_id': '20240122', 'student_name': '沈菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 12, 9), 'student_phone': '13800310022', 'class_id': 401},
        {'student_id': '20240123', 'student_name': '曾平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 9, 3), 'student_phone': '13800310023', 'class_id': 401},
        {'student_id': '20240124', 'student_name': '吴芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 1, 16), 'student_phone': '13800310024', 'class_id': 401},
        {'student_id': '20240125', 'student_name': '蔡军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 3, 24), 'student_phone': '13800310025', 'class_id': 401},
        {'student_id': '20240126', 'student_name': '余敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 7, 17), 'student_phone': '13800310026', 'class_id': 401},
        {'student_id': '20240127', 'student_name': '杜娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 11, 20), 'student_phone': '13800310027', 'class_id': 401},
        {'student_id': '20240128', 'student_name': '夏阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 5, 12), 'student_phone': '13800310028', 'class_id': 401},
        {'student_id': '20240129', 'student_name': '汪娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 2, 5), 'student_phone': '13800310029', 'class_id': 401},
        {'student_id': '20240130', 'student_name': '范勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 8, 27), 'student_phone': '13800310030', 'class_id': 401},
        {'student_id': '20240131', 'student_name': '钟雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 13), 'student_phone': '13800310031', 'class_id': 401},
        {'student_id': '20240132', 'student_name': '田超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 10, 1), 'student_phone': '13800310032', 'class_id': 401},
        {'student_id': '20240133', 'student_name': '姜伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 12, 22), 'student_phone': '13800310033', 'class_id': 401},
        {'student_id': '20240134', 'student_name': '崔丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 6, 15), 'student_phone': '13800310034', 'class_id': 401},
        {'student_id': '20240135', 'student_name': '顾强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 1, 26), 'student_phone': '13800310035', 'class_id': 401},
        {'student_id': '20240136', 'student_name': '侯梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 9, 7), 'student_phone': '13800310036', 'class_id': 401},

        # 2024级2班 (36人)
        {'student_id': '20240201', 'student_name': '徐杰', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 7, 10), 'student_phone': '13800320001', 'class_id': 402},
        {'student_id': '20240202', 'student_name': '沈婷', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 17), 'student_phone': '13800320002', 'class_id': 402},
        {'student_id': '20240203', 'student_name': '曹浩', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 3, 12), 'student_phone': '13800320003', 'class_id': 402},
        {'student_id': '20240204', 'student_name': '许燕', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 5, 18), 'student_phone': '13800320004', 'class_id': 402},
        {'student_id': '20240205', 'student_name': '邓军', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 11, 24), 'student_phone': '13800320005', 'class_id': 402},
        {'student_id': '20240206', 'student_name': '蔡琳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 13), 'student_phone': '13800320006', 'class_id': 402},
        {'student_id': '20240207', 'student_name': '杜伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 2, 17), 'student_phone': '13800320007', 'class_id': 402},
        {'student_id': '20240208', 'student_name': '夏芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 7, 24), 'student_phone': '13800320008', 'class_id': 402},
        {'student_id': '20240209', 'student_name': '汪翔', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 11), 'student_phone': '13800320009', 'class_id': 402},
        {'student_id': '20240210', 'student_name': '范敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 9, 3), 'student_phone': '13800320010', 'class_id': 402},
        {'student_id': '20240211', 'student_name': '钟娟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 12, 19), 'student_phone': '13800320011', 'class_id': 402},
        {'student_id': '20240212', 'student_name': '田阳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 6, 25), 'student_phone': '13800320012', 'class_id': 402},
        {'student_id': '20240213', 'student_name': '姜娜', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 1, 7), 'student_phone': '13800320013', 'class_id': 402},
        {'student_id': '20240214', 'student_name': '崔勇', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 10, 14), 'student_phone': '13800320014', 'class_id': 402},
        {'student_id': '20240215', 'student_name': '顾雪', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 7, 26), 'student_phone': '13800320015', 'class_id': 402},
        {'student_id': '20240216', 'student_name': '侯超', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 3, 11), 'student_phone': '13800320016', 'class_id': 402},
        {'student_id': '20240217', 'student_name': '徐伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 5, 19), 'student_phone': '13800320017', 'class_id': 402},
        {'student_id': '20240218', 'student_name': '沈丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 11, 27), 'student_phone': '13800320018', 'class_id': 402},
        {'student_id': '20240219', 'student_name': '曹强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 8, 16), 'student_phone': '13800320019', 'class_id': 402},
        {'student_id': '20240220', 'student_name': '许梅', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 4, 9), 'student_phone': '13800320020', 'class_id': 402},
        {'student_id': '20240221', 'student_name': '邓杰', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 10, 12), 'student_phone': '13800320021', 'class_id': 402},
        {'student_id': '20240222', 'student_name': '蔡菲', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 2, 23), 'student_phone': '13800320022', 'class_id': 402},
        {'student_id': '20240223', 'student_name': '杜平', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 6, 24), 'student_phone': '13800320023', 'class_id': 402},
        {'student_id': '20240224', 'student_name': '夏芳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 12, 14), 'student_phone': '13800320024', 'class_id': 402},
        {'student_id': '20240225', 'student_name': '汪军', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 9, 8), 'student_phone': '13800320025', 'class_id': 402},
        {'student_id': '20240226', 'student_name': '范敏', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 1, 23), 'student_phone': '13800320026', 'class_id': 402},
        {'student_id': '20240227', 'student_name': '钟娟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 3, 27), 'student_phone': '13800320027', 'class_id': 402},
        {'student_id': '20240228', 'student_name': '田阳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 7, 20), 'student_phone': '13800320028', 'class_id': 402},
        {'student_id': '20240229', 'student_name': '姜娜', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 11, 21), 'student_phone': '13800320029', 'class_id': 402},
        {'student_id': '20240230', 'student_name': '崔勇', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 5, 17), 'student_phone': '13800320030', 'class_id': 402},
        {'student_id': '20240231', 'student_name': '顾雪', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 2, 11), 'student_phone': '13800320031', 'class_id': 402},
        {'student_id': '20240232', 'student_name': '侯超', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 8, 26), 'student_phone': '13800320032', 'class_id': 402},
        {'student_id': '20240233', 'student_name': '徐伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 4, 18), 'student_phone': '13800320033', 'class_id': 402},
        {'student_id': '20240234', 'student_name': '沈丽', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 10, 8), 'student_phone': '13800320034', 'class_id': 402},
        {'student_id': '20240235', 'student_name': '曹强', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 12, 28), 'student_phone': '13800320035', 'class_id': 402},
        {'student_id': '20240236', 'student_name': '许梅', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 6, 19), 'student_phone': '13800320036', 'class_id': 402},

        # 2024级3班 (36人)
        {'student_id': '20240301', 'student_name': '邓杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 8, 9), 'student_phone': '13800330001', 'class_id': 403},
        {'student_id': '20240302', 'student_name': '蔡婷', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 9, 1), 'student_phone': '13800330002', 'class_id': 403},
        {'student_id': '20240303', 'student_name': '杜浩', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 3, 15), 'student_phone': '13800330003', 'class_id': 403},
        {'student_id': '20240304', 'student_name': '夏燕', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 5, 22), 'student_phone': '13800330004', 'class_id': 403},
        {'student_id': '20240305', 'student_name': '汪军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 11, 27), 'student_phone': '13800330005', 'class_id': 403},
        {'student_id': '20240306', 'student_name': '范琳', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 8, 11), 'student_phone': '13800330006', 'class_id': 403},
        {'student_id': '20240307', 'student_name': '钟伟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 2, 17), 'student_phone': '13800330007', 'class_id': 403},
        {'student_id': '20240308', 'student_name': '田芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 7, 25), 'student_phone': '13800330008', 'class_id': 403},
        {'student_id': '20240309', 'student_name': '姜翔', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 4, 10), 'student_phone': '13800330009', 'class_id': 403},
        {'student_id': '20240310', 'student_name': '崔敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 9, 6), 'student_phone': '13800330010', 'class_id': 403},
        {'student_id': '20240311', 'student_name': '顾娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 12, 22), 'student_phone': '13800330011', 'class_id': 403},
        {'student_id': '20240312', 'student_name': '侯阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 27), 'student_phone': '13800330012', 'class_id': 403},
        {'student_id': '20240313', 'student_name': '徐娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 1, 10), 'student_phone': '13800330013', 'class_id': 403},
        {'student_id': '20240314', 'student_name': '沈勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 10, 19), 'student_phone': '13800330014', 'class_id': 403},
        {'student_id': '20240315', 'student_name': '曹雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 7, 28), 'student_phone': '13800330015', 'class_id': 403},
        {'student_id': '20240316', 'student_name': '许超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 3, 13), 'student_phone': '13800330016', 'class_id': 403},
        {'student_id': '20240317', 'student_name': '邓伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 5, 22), 'student_phone': '13800330017', 'class_id': 403},
        {'student_id': '20240318', 'student_name': '蔡丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 11, 26), 'student_phone': '13800330018', 'class_id': 403},
        {'student_id': '20240319', 'student_name': '杜强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 8, 19), 'student_phone': '13800330019', 'class_id': 403},
        {'student_id': '20240320', 'student_name': '夏梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 4, 11), 'student_phone': '13800330020', 'class_id': 403},
        {'student_id': '20240321', 'student_name': '汪杰', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 10, 14), 'student_phone': '13800330021', 'class_id': 403},
        {'student_id': '20240322', 'student_name': '范菲', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 2, 26), 'student_phone': '13800330022', 'class_id': 403},
        {'student_id': '20240323', 'student_name': '钟平', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 6, 26), 'student_phone': '13800330023', 'class_id': 403},
        {'student_id': '20240324', 'student_name': '田芳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 12, 16), 'student_phone': '13800330024', 'class_id': 403},
        {'student_id': '20240325', 'student_name': '姜军', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 9, 10), 'student_phone': '13800330025', 'class_id': 403},
        {'student_id': '20240326', 'student_name': '崔敏', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 1, 22), 'student_phone': '13800330026', 'class_id': 403},
        {'student_id': '20240327', 'student_name': '顾娟', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 3, 29), 'student_phone': '13800330027', 'class_id': 403},
        {'student_id': '20240328', 'student_name': '侯阳', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 7, 23), 'student_phone': '13800330028', 'class_id': 403},
        {'student_id': '20240329', 'student_name': '徐娜', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 11, 19), 'student_phone': '13800330029', 'class_id': 403},
        {'student_id': '20240330', 'student_name': '沈勇', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 5, 18), 'student_phone': '13800330030', 'class_id': 403},
        {'student_id': '20240331', 'student_name': '曹雪', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 2, 12), 'student_phone': '13800330031', 'class_id': 403},
        {'student_id': '20240332', 'student_name': '许超', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 8, 28), 'student_phone': '13800330032', 'class_id': 403},
        {'student_id': '20240333', 'student_name': '邓伟', 'student_gender': '1', 'student_profession': '1',
         'student_birthday': date(2002, 4, 19), 'student_phone': '13800330033', 'class_id': 403},
        {'student_id': '20240334', 'student_name': '蔡丽', 'student_gender': '2', 'student_profession': '2',
         'student_birthday': date(2003, 10, 9), 'student_phone': '13800330034', 'class_id': 403},
        {'student_id': '20240335', 'student_name': '杜强', 'student_gender': '1', 'student_profession': '3',
         'student_birthday': date(2002, 12, 27), 'student_phone': '13800330035', 'class_id': 403},
        {'student_id': '20240336', 'student_name': '夏梅', 'student_gender': '2', 'student_profession': '4',
         'student_birthday': date(2003, 6, 20), 'student_phone': '13800330036', 'class_id': 403},
    ]

    # 创建学生数据
    created_count = 0
    for student_data in students_data:
        if not StudentInfo.objects.filter(student_id=student_data['student_id']).exists():
            class_obj = ClassInfo.objects.get(class_id=student_data['class_id'])
            StudentInfo.objects.create(
                student_id=student_data['student_id'],
                student_name=student_data['student_name'],
                student_gender=student_data['student_gender'],
                student_profession=student_data['student_profession'],
                student_birthday=student_data['student_birthday'],
                student_phone=student_data['student_phone'],
                student_class=class_obj
            )
            created_count += 1
            if created_count % 50 == 0:  # 每50个显示一次进度
                print(f"✓ 已创建 {created_count} 个学生...共432个")

    print(f"\n数据库初始化完成！")
    print(f"✓ 管理员账号: admin/123456")
    print(f"✓ 年级数据: {len(GradeInfo.objects.all())} 个")
    print(f"✓ 班级数据: {len(ClassInfo.objects.all())} 个")
    print(f"✓ 学生数据: {len(StudentInfo.objects.all())} 个")


if __name__ == '__main__':
    init_database_full()
